How to work with MS Excel | Microsoft Excel - 2019 | Beginners Tutorial for Excel | Chapter 1

2018-11-22 64

Microsoft Excel is an application program widely used for storing, calculating, organizing and formatting data in the form electronic worksheet also called spreadsheet. Excel is a part of Microsoft Office Suite which is produced and distributed by Microsoft Corporation.
It’s more than 30 years that Microsoft Excel is released, becoming one of the most popular tools in workplaces around the world. Whether you are digging into details of large data sets or, planning your budgeting strategy, Excel is a powerful program to help in all those business processes.
In order to learn more about working with Microsoft Excel please watch the following video.
Microsoft Excel contains billions of cell references in each worksheet which are used for data collection. These cells are further used as a reference for creating complex formula, reports, charts and on demand data analysis sheets.
The topics included in the beginner’s tutorial video are:
1. Data entry: How to enter data in the worksheet with the help of individual cell reference.
2. Format data: This includes widening of individual cell with respect to the width of the data or text entered.
3. Fonts: How to change the font, color, size, style of the individual or a group of cells in the worksheet.
4. Formula: How to use formula in the destination cell to calculate the desired result.
5. Editing: This includes adding, moving and copying of text, values and formula of one cell to another.
6. File open and save: This include opening and closing of spreadsheet in the computer for the further use.
Some strange facts about Microsoft Excel are:
Every Excel worksheet has 17179869184 that is 2^34 Cells till Excel 2016. If we take one second to fill one cell than it will take approximately 545 years to complete the entire worksheet.
Microsoft Office is used by more than 1.2 billion people and Microsoft Windows by 1.5 billion. This means more than 15 percent people of the world population uses Microsoft Excel and more than 20 percent uses Microsoft Windows.
Every time you click or enter data, Microsoft Excel calculates each cell entry depending on different cell values and formula. In this way up to 4 trillion formulas can depend on a single cell in Excel.